Tabela PsychiatricData

Definicja tabeli PsychiatricData

Name

PsychiatricData

Code

PsychiatricData

Comment

 


Lista kolumn tabeli PsychiatricData

Name

Code

PsychiatricDataID

PsychiatricDataID

EpisodeID

EpisodeID

PsychAdmissionNo

PsychAdmissionNo

PsychFirstAdmissionYear

PsychFirstAdmissionYear

PsychContractor

PsychContractor

PsychLastDischargeYear

PsychLastDischargeYear

PsychObservationArt

PsychObservationArt

PsychAdmissionModeID

PsychAdmissionModeID

PsychContractorID

PsychContractorID

PsychSourceOfIncomeID

PsychSourceOfIncomeID

PsychDirectedByID

PsychDirectedByID

PsychMaritalStatusID

PsychMaritalStatusID

PsychEducationID

PsychEducationID

PsychPlaceOfLiveID

PsychPlaceOfLiveID

PsychDisabledLevelID

PsychDisabledLevelID

PsychIncapacitatedLevelID

PsychIncapacitatedLevelID

PsychDischargeDirectionID

PsychDischargeDirectionID

PsychDischargeModeID

PsychDischargeModeID

PsychLastDischargeTimeID

PsychLastDischargeTimeID

PsychObservationID

PsychObservationID


Kolumna PsychiatricDataID tabeli PsychiatricData

Definicja kolumny PsychiatricDataID tabeli PsychiatricData

Name

PsychiatricDataID

Code

PsychiatricDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EpisodeID tabeli PsychiatricData

Definicja kolumny EpisodeID tabeli PsychiatricData

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PsychAdmissionNo tabeli PsychiatricData

Definicja kolumny PsychAdmissionNo tabeli PsychiatricData

Name

PsychAdmissionNo

Code

PsychAdmissionNo

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Admission number
PL: Numer przyjecia do szpitala (oddzialu) (Po raz który osoba zostala przyjeta)


Kolumna PsychFirstAdmissionYear tabeli PsychiatricData

Definicja kolumny PsychFirstAdmissionYear tabeli PsychiatricData

Name

PsychFirstAdmissionYear

Code

PsychFirstAdmissionYear

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Admission year
PL: Rok przyjecia do szpitala (oddzialu)


Kolumna PsychContractor tabeli PsychiatricData

Definicja kolumny PsychContractor tabeli PsychiatricData

Name

PsychContractor

Code

PsychContractor

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna PsychLastDischargeYear tabeli PsychiatricData

Definicja kolumny PsychLastDischargeYear tabeli PsychiatricData

Name

PsychLastDischargeYear

Code

PsychLastDischargeYear

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PsychObservationArt tabeli PsychiatricData

Definicja kolumny PsychObservationArt tabeli PsychiatricData

Name

PsychObservationArt

Code

PsychObservationArt

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna PsychAdmissionModeID tabeli PsychiatricData

Definicja kolumny PsychAdmissionModeID tabeli PsychiatricData

Name

PsychAdmissionModeID

Code

PsychAdmissionModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Admission mode
PL:Tryb przyjecia


Kolumna PsychContractorID tabeli PsychiatricData

Definicja kolumny PsychContractorID tabeli PsychiatricData

Name

PsychContractorID

Code

PsychContractorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PsychSourceOfIncomeID tabeli PsychiatricData

Definicja kolumny PsychSourceOfIncomeID tabeli PsychiatricData

Name

PsychSourceOfIncomeID

Code

PsychSourceOfIncomeID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Source of income
PL: Zródlo dochodu


Kolumna PsychDirectedByID tabeli PsychiatricData

Definicja kolumny PsychDirectedByID tabeli PsychiatricData

Name

PsychDirectedByID

Code

PsychDirectedByID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Directed by
PL: Skierowany przez


Kolumna PsychMaritalStatusID tabeli PsychiatricData

Definicja kolumny PsychMaritalStatusID tabeli PsychiatricData

Name

PsychMaritalStatusID

Code

PsychMaritalStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Marital status
PL: Stan cywilny


Kolumna PsychEducationID tabeli PsychiatricData

Definicja kolumny PsychEducationID tabeli PsychiatricData

Name

PsychEducationID

Code

PsychEducationID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Education
PL: Wyksztalcenie


Kolumna PsychPlaceOfLiveID tabeli PsychiatricData

Definicja kolumny PsychPlaceOfLiveID tabeli PsychiatricData

Name

PsychPlaceOfLiveID

Code

PsychPlaceOfLiveID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Place of live
PL: Miejsce zamieszkania


Kolumna PsychDisabledLevelID tabeli PsychiatricData

Definicja kolumny PsychDisabledLevelID tabeli PsychiatricData

Name

PsychDisabledLevelID

Code

PsychDisabledLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Disabled level
PL: Stopien niepelnosprawnosci


Kolumna PsychIncapacitatedLevelID tabeli PsychiatricData

Definicja kolumny PsychIncapacitatedLevelID tabeli PsychiatricData

Name

PsychIncapacitatedLevelID

Code

PsychIncapacitatedLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Level of incapacitation
PL: Poziom ubezwlasnowolnienia


Kolumna PsychDischargeDirectionID tabeli PsychiatricData

Definicja kolumny PsychDischargeDirectionID tabeli PsychiatricData

Name

PsychDischargeDirectionID

Code

PsychDischargeDirectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Discharge direction
PL: Wypisany dokad


Kolumna PsychDischargeModeID tabeli PsychiatricData

Definicja kolumny PsychDischargeModeID tabeli PsychiatricData

Name

PsychDischargeModeID

Code

PsychDischargeModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Discharge mode
PL: Wypisany jako


Kolumna PsychLastDischargeTimeID tabeli PsychiatricData

Definicja kolumny PsychLastDischargeTimeID tabeli PsychiatricData

Name

PsychLastDischargeTimeID

Code

PsychLastDischargeTimeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PsychObservationID tabeli PsychiatricData

Definicja kolumny PsychObservationID tabeli PsychiatricData

Name

PsychObservationID

Code

PsychObservationID

Data Type

NUMBER(10)

Mandatory

No

Comment

EN: Observation
PL: Obserwacja


Lista kluczy tabeli PsychiatricData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PsychiatricData

Definicja klucza Identifier_1 tabeli PsychiatricData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment